"There isn't enough memory to read worksheet" error when tried to open xlsx object from Powerpoint 2010

Hi,

I have a powerpoint presentation (will call it A.PPTX) which has an embedded spreadsheet object (B.XLSX). I was able to double click the object in "A" and open "B.XLSX" as and when necessary.

today, i opened B from the A and inserted another spreadsheet C.XLSX as an object in B. Closed all the files and saved A.PPTX. when i tried double click and tried to open B.XLSX from the powerpoint, i am getting an error "There isn't enough memory to read worksheet"

Unfortunately, i don't have a backup of B.XLSX as I always edited it by opening it from the presentation. is there a way to recover it?

Note: 

1. read through similar threads in the forum about errors while inserting objects or similar error in Powerpoint 2003. the solution provided did not help


August 26th, 2013 7:31am

Hi

By the description, you want to recover the embedded worksheet in PowerPoint.

Try following methods:

1.Click to the presentation file

2.Change the file extension from pptx to zip

3.Open the file, locate to ppt>embeddings

4.There you will see the embedded worksheet

5.Save the file to another path and open it

If the worksheet is still corrupted, following these steps to recover an Excel file:

1.Change the file extension from xlsx to zip

2.Open the file, locate to xl>workbook.xml

3. These XML files contain the data of each spreadsheet.

4.Copy the data to a new worksheet and save

Regards

Tylor Wang
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
August 27th, 2013 3:53am

Hi,Tylor.

my user have the same error.

Is there any way to repair the embedded worksheet instead to recover it?

in a pptx file,user had embedded out of 10 worksheets,but 3 worhsheets have this errors.

AND why does the error occur?

Thanks!


  • Edited by QinZhongg Tuesday, December 03, 2013 6:15 AM
December 3rd, 2013 6:13am

Awesome. It worked...!! Thanks for posting this. Really helped.
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2014 7:13am

I tried this and after attempting to open the XML file,received another error.  "XML file cannot be displayed...cannot view XML using style sheet.  Correct the error and try again".    

I am not sure what style sheet is or now to try to trouble shoot this.   This is a work presentation so I am anxious to get it restored.   Any guidance would be appreciated.

Thanks, 

Laura

July 31st, 2015 9:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics